package org.sanmao.wyj.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.sanmao.wyj.domain.Cashout;

@Mapper
public interface CashoutDao extends BaseMapper<Cashout> {
    @Select("select cashout.*,w.name as worker_name,w.phonenum as worker_phonenum from cashout left join worker as w on cashout.wid = w.wid where state = #{state}")
    IPage<Cashout> findCashoutList(IPage<Cashout> page, @Param("state")int state);
}
